Data Engineer Level II (Data-Enterprise Reporting)
Job Description
Data Engineer will work closely with the rest of the product team and business peers to effectively execute Data project initiatives. This person should be able to deliver in a fast-paced and deadline-driven environment. Along with development, candidate will be responsible for maintenance of the data applications and would be expected to automate the processes with no or minimal human intervention.
Strong SQLDevelopment and maintenance of ELT snowflake data warehouse solutionsCollaborate with internal and external technology and business partners to implement product changesProduce detail design and unit test documents, as requiredCritically analyze business requirements, architect and implement Data solutionsDefine, develop and maintain standards and processes to ensure effective ETL solutionProduction maintenanceWork closely with product manager to develop and execute action plans to address gapsRecommend innovations that enhance and/or provide a competitive advantage to the organizationCommunicate effectively with both the business and technical teamsMentor junior offshore developers to accomplish resultsBuild and continuously improve data engineering best practices
Qualification
Min 8 years of Data engineering experience using ETL/ELT technologies
6+ years ETL/ELT experience working with IICS, Informatica, StreamSets, DBT, Python, Data bricks, Snowflake and ADF or equivalent technologies
1 year hands on experience with Snowflake
Experience working with SSIS, SSRS, and Power BI
1 year hands on experience working in an Azure environment.
Experience working in insurance or reinsurance industry is highly desirable
3+ years hands on experience with agile methodologies
Experience with Data warehouse/ data lake/ data hub modeling
Experience working with external data feed to enrich internal data- desired
3+ years hands on experience with data standardization/conformance/transformation process
Solid understanding of MDM and reference data
3+ years hands on experience with CI/CD process, especially in data engineering
Experience working in SOX and SOC-2 compliant environment
Experience with automated monitoring of data loads
Support of production environment
Strong understanding of technologies utilized in the industry and the ability to see their impact as well as enhancement management and product lifecycle development
Knowledge of source code version control systems such as Git including branching/merging, resolving code conflicts, and 3-way and baseless merges
Relevant experience working with 3rd party vendors to deliver results
About The Specialty Insurance Company
The company is a global leader in providing specialty insurance, reinsurance, and mortgage insurance solutions.